Crime Reports in Seattle
Motivation for the Project
Seattle, one of the most popular cities in the US, is known to have a high population.
Due to its high population, crime is unavoidable in the city. Recognizing the concern, we desire to create a data visualization that visually conveys the type and location of reported crimes.
We are interested in the topic because identifying patterns in past crimes not only help professionals make informed decisions to combat the war with crime but also informs the general public about the critical information regarding public safety. Police officers, government officials, and others can use insights from this data to try implementing and enforcing different solutions to reduce crime rates. We believe that this type of data-driven decision making can have a positive impact on cities all around the world.
To obtain credible data, we collected our data sources are from Seattle.gov. The Seattle Police Department created all three data that we used for the project. Dataset 1 provides information about criminal incidents from 2008-present day, as well as the type of crime, its location, and how frequently that type occurs.
| Sectors | Total Primary Offenses | Most Occured Crime Frequency | Most Occured Crime | Number of Call Logs |
|---|---|---|---|---|
| BOY | 74 | 8 | Assault | 64 |
| CHARLIE | 35 | 9 | Assault | 34 |
| DAVID | 71 | 9 | Assault | 73 |
| EDWARD | 53 | 8 | Assault | 54 |
| FRANK | 53 | 9 | Assault | 46 |
| GEORGE | 51 | 9 | Assault | 53 |
| JOHN | 39 | 9 | Assault | 44 |
| KING | 82 | 8 | Assault | 96 |
| LINCOLN | 56 | 9 | Assault | 48 |
| MARY | 79 | 6 | Assault | 85 |
| NORA | 50 | 9 | Assault | 51 |
| NULL | 50 | 9 | Assault | 15 |
| OCEAN | 26 | 9 | Assault | 38 |
| QUEEN | 73 | 8 | Assault | 44 |
| ROBERT | 71 | 9 | Assault | 73 |
| SAM | 60 | 8 | Homicide | 74 |
| UNION | 60 | 8 | Assault | 55 |
| WILLIAM | 38 | 9 | Burglary | 53 |
| ### Added | description and insights | of agg table -Yunwei |
Crime Report from 2008-present day
A precinct is an area whose boundaries are determined by the police for their investigative purposes. As indicated by this graph, the North precinct of Seattle is the most dangerous based on the number of crimes that have occured from 2008 to present day.
Relations of Crime and Call Data
(from SPD Communications Center)
get rid of pie chart later- yunwei
This data comes from Seattle Police Department’s Communications Center’s record of log calls, including 911 calls, etc.The pie chart shows the top 10 most common Initial Call Type received from 2008 to present day. Of these call types, the most common ones are simple Premise Checks and Traffic Violations. However, there are also more serious crimes such as Burglary and Narcotics. ### delet this pie chart section -yunwei
Number of Crime Reports in Seattle Neighborhood
This data comes from The Seattle Police Department provided this data on the Seattle.gov website. It includes information about the crime that was reported in different neighborhoods in Seattle. There are total 524k rows, and 11 columns and each row is a unique crime reported record. The visualization focused on the number of crime reports in different neighborhoods in Seattle